SQL для тестировщика

Даны следующие таблицы:

Employees

+-----------+---------+------------+
| EmployeeID|  Name   | Department |
+-----------+---------+------------+
|     1     |  John   |     HR     |
|     2     |  Jane   |     IT     |
|     3     |  Mark   |     HR     |
|     4     |  Sarah  |     IT     |
|     5     | Michael |  Finance   |
+-----------+---------+------------+

Salaries
+-----------+--------+
| EmployeeID| Salary |
+-----------+--------+
| 1 | 5000 |
| 2 | 6000 |
| 3 | 5500 |
| 4 | 6500 |
| 5 | 7000 |
+-----------+--------+

Какой из следующих SQL запросов отберет имена работников, имеющих зарплату большую или равную 6000?

A) SELECT Name FROM Employees WHERE Salary > 6000

B) SELECT Name FROM Employees JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

C) SELECT Name FROM Employees INNER JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

D) SELECT Name FROM Employees WHERE Salary >= 6000 JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID

www.tg-me.com/cn/SQL для тестировщика/com.sql_for_qa/116

2.0K viewsJun 30, 2023 at 09:11

Даны следующие таблицы:

Employees

+-----------+---------+------------+
| EmployeeID|  Name   | Department |
+-----------+---------+------------+
|     1     |  John   |     HR     |
|     2     |  Jane   |     IT     |
|     3     |  Mark   |     HR     |
|     4     |  Sarah  |     IT     |
|     5     | Michael |  Finance   |
+-----------+---------+------------+

BY SQL для тестировщика